UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+3XWe3POWTvCaQi9ngTR8FSavc7FU5dtY1e7S7MX6bg='
WHERE
key_id = 'b7dd8e9dda4b6d56b4283ed8b79f683e0c51682054aa9a09e9ef792c44162b5d'
AND (
token = '+3XWe3POWTvCaQi9ngTR8FSavc7FU5dtY1e7S7MX6bg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)