UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WXsXbNHgAQQEiF7Je8CoC6VlZjJfY3dN04O8eFoMhMM='
WHERE
key_id = 'f5f6848887f94b051b9f4789ef1417d8b00348de11feb4cfd90fad558e469ef6'
AND (
token = 'WXsXbNHgAQQEiF7Je8CoC6VlZjJfY3dN04O8eFoMhMM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)