UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lB6c81Zh8q9cqHFZPu1un+dkRhvKwo6xqdKjRj7iuSI='
WHERE
key_id = 'a97d8a76274f373f65ddf468aeb0f792bb3f9b6a11b5dbe627356034ee17cb7a'
AND (
token = 'lB6c81Zh8q9cqHFZPu1un+dkRhvKwo6xqdKjRj7iuSI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)