UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vVYPxurbsCxYLb5I1U5qCWA5UoFhSgoGDr0aDVra5zc='
WHERE
key_id = 'e3741d7a64ee28a6bdd58c2b22b7ac22ed0f6317147b162c32a42948f3f6b2fa'
AND (
token = 'vVYPxurbsCxYLb5I1U5qCWA5UoFhSgoGDr0aDVra5zc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)