UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BjXGYPxUwIYDqHM+s4Mp4K2akXNe+/RnTmVaRI/MLGc='
WHERE
key_id = '4947da5f18df56e7f36dd1a0ba959fd3e790b6efb540864b64aacca94dfbb53d'
AND (
token = 'BjXGYPxUwIYDqHM+s4Mp4K2akXNe+/RnTmVaRI/MLGc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)