UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2AZ6yCvcnEv/ZXdXuhleDhPDnDGAc9zBzmZAGCyRWto='
WHERE
key_id = '2d9e861741ea532a28a543e84969e668e662131236cef1edb28b7b4341f226fc'
AND (
token = '2AZ6yCvcnEv/ZXdXuhleDhPDnDGAc9zBzmZAGCyRWto='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)