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