UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd1zhF7wfwvPRvUZ5WjcRfOqIVU5HwbDRD8Mr621ctNU='
WHERE
key_id = '917291d4e3f1a0d59cad022b4aaf24348bc0c171fd34c5c867063c6e67dbb570'
AND (
token = 'd1zhF7wfwvPRvUZ5WjcRfOqIVU5HwbDRD8Mr621ctNU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)