UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qFarZ5yfxsJpZ9egbFCuYmJ1W/p+5HVNBC/pYyKpFvU='
WHERE
key_id = 'a64cf789298bcdd214ec3e06c5bd331380434926b710ce560a3d957c140e14cc'
AND (
token = 'qFarZ5yfxsJpZ9egbFCuYmJ1W/p+5HVNBC/pYyKpFvU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)