UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pkEfEVYKYLPfJxvV7Pc5WMiiY2jpJlcPMSc1fTFrvec='
WHERE
key_id = '831d68c3a70ac6258a9735903aa5dfdb0522dc72a2274ea8520ee63acd274b64'
AND (
token = 'pkEfEVYKYLPfJxvV7Pc5WMiiY2jpJlcPMSc1fTFrvec='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)