UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YW6rmP6cv9aOfpv3D+X1huPgMT2wH3xYuRGAX3LKkYg='
WHERE
key_id = '6d9bee04fdabde5c63ab19fdc5ea01361c8383171c0772f4261da7c77721b88f'
AND (
token = 'YW6rmP6cv9aOfpv3D+X1huPgMT2wH3xYuRGAX3LKkYg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)