UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'siZMw/vSaGngNXJZLZX4mBL1ZjZ/cGWt8hMvfUZ9egU='
WHERE
key_id = 'a2c177e7fe636605aa5297fc47f45ea46b92d34a09dea742e506bd22e967ef60'
AND (
token = 'siZMw/vSaGngNXJZLZX4mBL1ZjZ/cGWt8hMvfUZ9egU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)