UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RZo87Hl0IIquBlio93m8yRHahoJIJcdaBCng3oF6Jdw='
WHERE
key_id = 'b83661bc62e49686ce28ab9983c5a5d07eafc950e96a0945283b5649499ea22f'
AND (
token = 'RZo87Hl0IIquBlio93m8yRHahoJIJcdaBCng3oF6Jdw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)