UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TQ+HieXb1h+COBGzJksu1R26jxwgKOVCCyREHI1MMGE='
WHERE
key_id = 'bbe331d448fc004fe45a83984a6c2335682775d540bcce608d3021f8bff1649d'
AND (
token = 'TQ+HieXb1h+COBGzJksu1R26jxwgKOVCCyREHI1MMGE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)