UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cMR6xdEtX+OkuAqgGDgk0dFlSMUlynOs+tICNGmso18='
WHERE
key_id = '254270e31c13b221cc76731fe02c8367626a33c3932177038b0fc245e2a8ee12'
AND (
token = 'cMR6xdEtX+OkuAqgGDgk0dFlSMUlynOs+tICNGmso18='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)