UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AfMV8f31vDGMmr0BB1Y2rI1yLLS/aaBASqADPhd0eoE='
WHERE
key_id = '012ed7f3ed0f8c05ca8d5ecc5a8ea2647c3e9133b3de31233c08b5a0719ff5cf'
AND (
token = 'AfMV8f31vDGMmr0BB1Y2rI1yLLS/aaBASqADPhd0eoE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)