UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bXgD7yyuhzPwB+mmrfjcUWAV2FqMywRmAcPluQV3kjM='
WHERE
key_id = '111f347d2bc033d1e7be37767f79da1e1d01255cef8d5bb753332f6c8c920528'
AND (
token = 'bXgD7yyuhzPwB+mmrfjcUWAV2FqMywRmAcPluQV3kjM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)