UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7hUgoAx6qh2QhsuyqCpKwKpJV8sgvGkSOlXa9WiTnus='
WHERE
key_id = 'aed57ed0f62c6adc5d166b40a097d97455cfb7a4a8cb6a120f5f4b19586631ca'
AND (
token = '7hUgoAx6qh2QhsuyqCpKwKpJV8sgvGkSOlXa9WiTnus='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)