UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'V+sBH38AV3hMsbfmAEqwcMzIO5i+jMCsibdF2E44UMg='
WHERE
key_id = '67f9f63d725c7b21f229c96ea4e179512ac8400691e6724535bfd8887b1fe877'
AND (
token = 'V+sBH38AV3hMsbfmAEqwcMzIO5i+jMCsibdF2E44UMg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)