UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1ZtWe8Vj9hf2eJYlcuQE+5DAnnZpAY8Q3mi3ZGLvPJo='
WHERE
key_id = '4e6eb18b94777a2be54dfa84a6d34e03a8fb0dca0c587613bc8bc0a08e99da12'
AND (
token = '1ZtWe8Vj9hf2eJYlcuQE+5DAnnZpAY8Q3mi3ZGLvPJo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)