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