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