UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Sp178NFgXLuPXJQZx8MWOmdX3eofM9OtUEzU+KSNJXg='
WHERE
key_id = 'ad2c31161021d29a9f7b4c113170d1771f0ba6cf4cb33ae9b080f55ab14f7bd4'
AND (
token = 'Sp178NFgXLuPXJQZx8MWOmdX3eofM9OtUEzU+KSNJXg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)