UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KN1+bhCd+27KSK1JCa/KwE7TsnMx0yAqvtOQ4E7yqwY='
WHERE
key_id = 'e20c60a2a51f2558e27f3b9d0b08ea6db9383a5c3ab0ec91fb006d5ff1162514'
AND (
token = 'KN1+bhCd+27KSK1JCa/KwE7TsnMx0yAqvtOQ4E7yqwY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)