UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fOx6kWbaur2wIBhbqusjMIR07M9Wk7sB2fVRVU2heAg='
WHERE
key_id = '48ca6b794e6d621fe73ca3eeb297d1e37ff1053ba6503432c34f1ded877ec524'
AND (
token = 'fOx6kWbaur2wIBhbqusjMIR07M9Wk7sB2fVRVU2heAg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)