UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zO269e7u6GEjHOyQsbn5NH+CiswVEiemCWkfwdeP/hQ='
WHERE
key_id = 'c258ad8c7e8c1f3ee3674131763e5dca5cd4eb4110981904ae45d3b7cae96efd'
AND (
token = 'zO269e7u6GEjHOyQsbn5NH+CiswVEiemCWkfwdeP/hQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)