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