UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HGPF0BVcs83DTL/zHBxQczZfmooOZOfl5p+8WgXzCA8='
WHERE
key_id = 'be77c573dcb2d384cc3b8801200fe12ecacf72c58cce0c19a5f82fce7e5b6ce0'
AND (
token = 'HGPF0BVcs83DTL/zHBxQczZfmooOZOfl5p+8WgXzCA8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)