UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6N6eoUbIWT/l7M7KXJ9Y5dX+kr1+VKd6OichVBfL65M='
WHERE
key_id = '1bbf2e9d8f6c937a5ae3fd608e22d2aa7f20b7923f4f9e7b147d3d6ab7b34f9d'
AND (
token = '6N6eoUbIWT/l7M7KXJ9Y5dX+kr1+VKd6OichVBfL65M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)