UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZinwkgMhSWE02LefZ5lJAviSgqvYHntAYzFz1yvoTqM='
WHERE
key_id = '5769874eee098bc684a6d657057b6384b07459cedae3bd5f6685f37ec09ace3f'
AND (
token = 'ZinwkgMhSWE02LefZ5lJAviSgqvYHntAYzFz1yvoTqM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)