UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nuOTQCN1q6gYHECgpCsU/T08e+tNI1MiZ4nhsnbtloE='
WHERE
key_id = 'a503b3dac65b602715eb3cf464d0c7c0028c637ce88d682edcfa0efb958dd8bf'
AND (
token = 'nuOTQCN1q6gYHECgpCsU/T08e+tNI1MiZ4nhsnbtloE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)