UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4eRlVnYAFKo1N8YPJtzbRb4wa3xn9TQBE5wELlPoFmY='
WHERE
key_id = '77295049d2c6338f893a215b4e33df2411f2047c38bccb765a8e25a922a8762d'
AND (
token = '4eRlVnYAFKo1N8YPJtzbRb4wa3xn9TQBE5wELlPoFmY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)