UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gTxrvofK1lcWBLfWA0Cc+HPdD7m9Qm6woepwIXgx3G8='
WHERE
key_id = 'a7d81be3fde4182a54c1d9418c4f13afda309f84a2879189a938875f0a662f3f'
AND (
token = 'gTxrvofK1lcWBLfWA0Cc+HPdD7m9Qm6woepwIXgx3G8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)